| |
4964 Search Results Found |
| 1 |
Forum: SQL & PL/SQL «»
Posted on: Wed, 27 September 2023 16:26 «»
By: Duane
Inserted JSON into Column is being Truncated
…thinking!","postId":100,"user":{"id":63,"username":"eburras1q"}},{"id":2,"body":"What terrific math skills you’re showing!","postId":27,"user":{"…
|
| 2 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 28 September 2023 11:33 «»
By: Barbara Boehmer
Re: Inserted JSON into Column is being Truncated
…thinking!","postId":100,"user"
:{"id":63,"username":"eburras1q"}},{"id":2,"body":"What terrific math skills you
’re showing!","postId":27,"user":{&…
|
| 3 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 28 September 2023 01:00 «»
By: Barbara Boehmer
Re: Inserted JSON into Column is being Truncated
…thinking!","postId":100,"user"
:{"id":63,"username":"eburras1q"}},{"id":2,"body":"What terrific math skills you
’re showing!","postId":27,"user":{&…
|
| 4 |
Forum: Server Administration «»
Posted on: Wed, 03 May 2023 11:25 «»
By: Andrey_R
session parameters AUTO-change for specific user
…DBAs,
Strange behavior of that one specific user.
My system-wide, and therefore my session parameter values for "DB_FILE_MUTLIBLOCK_READ_COUNT" & "OPTIMIZER_MODE" , for user "OK_USER" are 8 and FIRST_ROWS_100:
…
|
| 5 |
Forum: SQL & PL/SQL «»
Posted on: Sat, 05 January 2002 21:19 «»
By: diana365
create user
…table for a database .
how could we create user that could use our database?.
we should have 3 level view - customer, worker and programmer,
and every level has differrent privilages.
i''d try create user..but an error occur saying that
SQL> create …
|
| 6 |
Forum: SQL & PL/SQL «»
Posted on: Mon, 14 January 2002 01:17 «»
By: camelia
oracle user_views.
How can I find out what views already exists for Oracle. For example user_tab_columns.
Does exist a view like user_tab_columns but which returns only information regarding tables not tables and views.
thanks.
|
| 7 |
Forum: SQL & PL/SQL «»
Posted on: Wed, 07 February 2024 10:46 «»
By: Michel Cadot
Re: Querying table permissions to see which users have them
…rlined.
We create a table in TEST schema, 3 users T1, T2, T3 and 3 roles R1, R2, R3 which are respectively granted to T1, T2 and T3 and R1 is granted to R2 and R2 to R3.
Then we give privileges on the table to SCOTT and the roles:
create table test.t…
|
| 8 |
Forum: Marketplace «»
Posted on: Sun, 20 March 2016 11:35 «»
By: Michel Cadot
McOptions: a program which allows to know which options are used in a database
…erts.
and <logon> is:
{ <username>[/<password>][@<connect_identifier>]
| /[@<connect_identifier>] }
| <proxyuser>[<username>][/<password>][@<connect_identifier>]
| [&…
|
| 9 |
Forum: Forms «»
Posted on: Tue, 16 May 2023 05:06 «»
By: mfahimaamirgmailcom
table right user
…
when i given the table name with owner user name
scott.emp then form run right with fahim user
how to user fahim directly use the EMP form for data feeding
this is database right issue or form issue
i given all right to fahim user…
|
| 10 |
Forum: Security «»
Posted on: Mon, 04 March 2024 02:52 «»
By: Andrey_R
Grant DBA role using procedure doesn't work
…why when I grant direct DBA role to user I can access views such as DBA_TABLES,
while when granted using a procedure it doesn't.
Direct Grant:
SQL> show user
USER is "SYS"
SQL> create user t identified by t;
User created…
|
| 11 |
Forum: SQL & PL/SQL «»
Posted on: Sat, 03 December 2022 04:44 «»
By: Solomon Yakobson
Re: Value multiple
… STRAGG you could use MODEL:
Run this for user input:
column select_list new_value select_list noprint
set verify off
accept user_input prompt "Please enter value: "
Then run:
select select_list
from dual
model
…
|
| 12 |
Forum: Business Intelligence «»
Posted on: Thu, 18 May 2023 02:10 «»
By: annu-agi
oca user session information
…experts
i have requirement for logging user session usage for OCA users.
question is
do we have any tables to store
user login and session duration with date and time ?
user usage report which user uses dashboard, queries, xml-reports and …
|
| 13 |
Forum: SQL & PL/SQL «»
Posted on: Tue, 16 April 2024 10:02 «»
By: watisditnou@msn.com
Convert input from user into UPPERCASE
…Oracle i have made a script to create a user after the input of a name
var muser VARCHAR2(10)
ACCEPT muser CHAR PROMPT 'Give username :'
CREATE USER "&&muser" PROFILE "WORK" IDENTIFIED BY "Test123" PASSWORD …
|
| 14 |
Forum: Performance Tuning «»
Posted on: Fri, 22 July 2022 16:35 «»
By: Andrey_R
Re: Time metrics in V$SQL don't add up
…for the data to be fetched over to the user process and displayed in the session.
I do not see it adding up to some understandable factor or such, but I do seem to recognize some consistency in some indications in my test:
So here it goes. First I'm …
|
| 15 |
Forum: SQL & PL/SQL «»
Posted on: Fri, 11 January 2002 04:54 «»
By: James Briar
Killing a user session
…kill a user session i can use :-
alter system kill session '7,140';
But how do i amend the above alter command to use Bind variables that hold the values 7 and 140 instead of actually putting in 7 and 140 (assuming you can do this).
For example i've …
|
| 16 |
Forum: Server Administration «»
Posted on: Wed, 01 March 2023 10:44 «»
By: wtolentino
Audit Logon of Specific User
… trying to create an audit policy whenever a user attempts to logon and could not connect successfully because of incorrect password. I tried this command and I am getting an error:
create audit policy connect_spiuser_policy actions logon
when '…
|
| 17 |
Forum: Data Guard «»
Posted on: Sun, 11 September 2022 04:14 «»
By: Andrey_R
Query-Only non-SYS user for Mounted instance
… and other DMVs.
I am able to do it with user SYS, or any user I give SYSDBA privileges to.
If I try with a non-SYS user, as the instance is in MOUNT state - it results in
SQL*Plus: Release 19.0.0.0.0 - Production on Sun Sep 11 12:09:06 2022…
|
| 18 |
Forum: SQL & PL/SQL «»
Posted on: Tue, 02 April 2024 12:52 «»
By: noname369
Implement Profile, PW Policy & Roles
…"_ORACLE_SCRIPT"=true;
--Create Users
CREATE USER DBSEC_ADMIN IDENTIFIED BY password DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP;
CREATE USER DBSEC_CLERK IDENTIFIED BY password DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP;
…
|
| 19 |
Forum: Application Express, ORDS & MOD_PLSQL «»
Posted on: Fri, 10 March 2023 15:04 «»
By: wtolentino
How To Get APEX users who are currently active
…get the workspaces I would query the dba_user views
USERNAME USER_ID
------------------------- ----------
APEX_030200 190
APEX_LISTENER 262
APEX_PUBLIC_USER 170
…
|
| 20 |
Forum: SQL & PL/SQL «»
Posted on: Tue, 12 April 2022 00:14 «»
By: jury68000
Re: Help Needed in Oracle Referenced Column DataType
…POSITION,
c.data_type,
c.data_length
FROM USER_CONSTRAINTS A, USER_CONS_COLUMNS B, user_tab_columns c
WHERE B.CONSTRAINT_NAME = A.CONSTRAINT_NAME
AND A.CONSTRAINT_TYPE = 'R'
--and b.owner = c.owner
and b.table_name = c.table_name
and b.column_name…
|
| 21 |
Forum: SQL & PL/SQL «»
Posted on: Wed, 07 February 2024 15:06 «»
By: Michel Cadot
Re: Querying table permissions to see which users have them
…in the query result this means that every user can do the authorized action.
As in (line INDEX):
SQL> grant index on test.t to public;
Grant succeeded.
SQL> Column priv_ FORMAT A30 HEADING 'Privilege'
SQL> Column user_ FORMAT A20 &…
|
| 22 |
Forum: Server Administration «»
Posted on: Mon, 24 April 2023 13:10 «»
By: Michel Cadot
Re: disconnect the schema
…s.
SQL> create or replace procedure stop_user (p_user in varchar2)
2 is
3 begin
4 execute immediate 'alter user '||dbms_assert.schema_name(p_user)||' account lock';
5 for …
|
| 23 |
Forum: SQL & PL/SQL «»
Posted on: Sat, 26 November 2022 05:32 «»
By: Solomon Yakobson
Re: Value multiple
… select_list noprint
set verify off
accept user_input prompt "Please enter value: "
select stragg('amount * ' || level || ' "' || level || '",') select_list
from dual
connect by level <= &&user_input
/
select …
|
| 24 |
Forum: Security «»
Posted on: Tue, 27 September 2022 09:17 «»
By: evoradba
how to retrieve user logging 120 days ago
…
how do I see oracle 12c user activity 120 days ago? im looking for a select statment showing users login to the database more then 120 days ago, is this possible?
SELECT c.username,
a.SAMPLE_TIME,
a.SQL_EXEC_START,
b.…
|
| 25 |
Forum: SQL & PL/SQL «»
Posted on: Tue, 12 February 2002 12:08 «»
By: Sal wheelar
User Authentication by SQL Queries ???
…I authenticate database user without connecting to database by passing userid and password.
Suppose I have connected to database as User1.
Can I issue queries with userid and passwords as parameters of other users to check whether they are valid users…
|
| 26 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 17 January 2002 04:56 «»
By: S. Hill
need to create a "read only" user
…need to create a user(lets call this user USER1) that can only select data in user2's tables (just allow USER1 to read the data only). User2 owns the tables. There are over 400 tables so I don't want to grant select on each one. Is there someway to grant …
|
| 27 |
Forum: Forms «»
Posted on: Thu, 07 September 2023 01:05 «»
By: shabuddinakshaikh
How do I force user to enter child records on creating a new parent record
…blocks. The requirement is that when the user enters a new record in the parent block, we have to force the user to enter details in the child block as well. User cannot change tabs or save the data till the parent - child data is entered well.
I have …
|
| 28 |
Forum: Forms «»
Posted on: Thu, 31 August 2023 05:16 «»
By: mfahimaamirgmailcom
Menu roles table: how to create and use it
…code in startup code
declare
l_username varchar2(40);
begin
l_username := get_application_property(username);
SET_MENU_ITEM_PROPERTY('MANUMENUWINDOW.TEST1',ENABLED,PROPERTY_FALSE);
end;
Dear Sir, I followed this code, but the …
|
| 29 |
Forum: SQL & PL/SQL «»
Posted on: Mon, 24 October 2022 04:57 «»
By: fixxxer
ORA-29005: The certificate is invalid
…server. I have assigned the ACL to the user in question, with connect and resolve permissions. The certificate has been added to the oracle wallet.
If I run the below select (to validate the connection) it works for SYS user:
SQL> SELECT …
|
| 30 |
Forum: SQL & PL/SQL «»
Posted on: Wed, 16 February 2022 02:45 «»
By: piripicchio
Re: Getting ORA-24374 , when using function in with query
… 9 | TABLE ACCESS BY INDEX ROWID| USER$ | 1 | 15 | 1 (0)| 00:00:01 |
|* 10 | INDEX UNIQUE SCAN | I_USER1 | 1 | | 0 (0)| 00:00:01 |
|* 11 | INDEX RANGE SCAN…
|
| 31 |
Forum: SQL & PL/SQL «»
Posted on: Tue, 16 April 2024 10:52 «»
By: Barbara Boehmer
Re: Convert input from user into UPPERCASE
…us:
SCOTT@orcl_12.1.0.2.0> COLUMN muser NEW_VALUE v_user NOPRINT
SCOTT@orcl_12.1.0.2.0> ACCEPT muser CHAR PROMPT 'Give username :'
Give username :Test123
SCOTT@orcl_12.1.0.2.0> SELECT UPPER('&&muser') AS muser FROM DUAL
…
|
| 32 |
Forum: SQL & PL/SQL «»
Posted on: Fri, 08 March 2024 13:13 «»
By: Darth Waiter
Prevent user from executing a script until they will have read and understood it
…all,
I want to give users a script that they will need to run on their own but they first must take certain actions.
Of which they will learn by reading the script or at least the comment header in it. If they choose to ignore me it is their decision to…
|
| 33 |
Forum: SQL & PL/SQL «»
Posted on: Mon, 05 February 2024 15:16 «»
By: Darth Waiter
Querying table permissions to see which users have them
…my test environment, I created a user C##SOMEBODY, and that user created a few tables.
I want to find out who has permissions to those tables. That user should be included in the results because it owns its tables.
So far I tried (results in the …
|
| 34 |
Forum: Server Administration «»
Posted on: Mon, 05 February 2024 10:38 «»
By: wtolentino
Re: Grants of Select Privilege Thru Stored Procedure
…to execute the procedure
SQL> select user from dual;
USER
--------------------------------------------------------------------------------
SQLDBA
USER
--------------------------------------------------------------------------------
SQLDBA…
|
| 35 |
Forum: Client Tools «»
Posted on: Sun, 21 January 2024 08:22 «»
By: Lionel94
Script to catch ALL Error in sqlplus (SQL, OS and SP2)
… termout off linesize 500
column SUBST_OS_USER new_val OS_USER
column SUBST_HOST new_val HOST
column SUBST_EXECUTION_DATE new_val EXECUTION_DATE
…
|
| 36 |
Forum: Application Express, ORDS & MOD_PLSQL «»
Posted on: Thu, 21 July 2022 08:21 «»
By: John Watson
Re: Temporarily change the INTERNAL / ADMIN password
…
Connected.
orclz> select spare4 from user$ where name='SCOTT';
SPARE4
--------------------------------------------------------------------------------
S:406C1987463E5AE09E6B2FD24A10360CECCC5FD2CACE9EA3E5F9024D1080;T:BAF7E6885884D1B
…
|
| 37 |
Forum: Application Express, ORDS & MOD_PLSQL «»
Posted on: Wed, 20 July 2022 06:03 «»
By: John Watson
Temporarily change the INTERNAL / ADMIN password
…need to reset the ADMIN user password for the INTERNAL workspace, do a couple of things in the admin GUI, and then set the password back to what it was before. But I don't know what the current password is. This routine seems to work:
grant dba, …
|
| 38 |
Forum: SQL & PL/SQL «»
Posted on: Tue, 12 April 2022 09:27 «»
By: EdStevens
Re: Help Needed in Oracle Referenced Column DataType
…of resolving object names.
SQL> show user
USER is "SCOTT"
SQL> -- -------- create the tables
SQL> create table Case_Insensitive
2 (fname varchar2(10)
3 )
4 ;
Table created.
SQL> create table "…
|
| 39 |
Forum: Marketplace «»
Posted on: Wed, 17 August 2016 09:46 «»
By: Michel Cadot
McDP: like expdp/impdp Data Pump programs and much more
…command)
Get the DDL of one or more Oracle users with or without their privileges to help you recreate them (USER command)
Copy a schema or part of it into another or the same one and a remote or local database (COPY command)
Copy tables and views …
|
| 40 |
Forum: SQL & PL/SQL «»
Posted on: Tue, 16 April 2024 11:20 «»
By: Michel Cadot
Re: Convert input from user into UPPERCASE
…
Just remove the " around the user name in CREATE USER then you don't need to upper case, Oracle will do it:
SQL> select username from all_users where username='TEST123';
no rows selected
SQL> create user test123 identified by "…
|
Blog
Search
Help
Members
Register
Login
Home